home *** CD-ROM | disk | FTP | other *** search
Text File | 1990-02-08 | 51.9 KB | 1,321 lines |
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Table of Contents Table of Contents
-
-
-
-
-
- Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . 1
- Copyright and Registration Information . . . . . . . . . . . 1
- How to Contact Bowen Software . . . . . . . . . . . . . . . 1
- Software Support . . . . . . . . . . . . . . . . . . . . . . 2
- Trademark Acknowledgements . . . . . . . . . . . . . . . . . 2
- Disclaimer and Warranty . . . . . . . . . . . . . . . . . . 2
-
- Getting Started . . . . . . . . . . . . . . . . . . . . . . . . . 3
- Description . . . . . . . . . . . . . . . . . . . . . . . . 3
- Limitations . . . . . . . . . . . . . . . . . . . . . . . . 3
- Cautions . . . . . . . . . . . . . . . . . . . . . . . . . . 3
- Installing PopDBF Files on Your Hard Disk . . . . . . . . . 4
- Modifying AUTOEXEC.BAT to Load PopDBF . . . . . . . . . . . 4
- How to Invoke PopDBF (Using the "Hotkey") . . . . . . . . . 5
- Command Line Arguments . . . . . . . . . . . . . . . . . . . 5
- /A<ltr> Default action . . . . . . . . . . . . . . . 5
- /D<dir> Initial PopDBF Directory . . . . . . . . . . 5
- /Fnnnn Maximum of nnnn fields . . . . . . . . . . . 6
- /H Display brief description of command line
- arguments. . . . . . . . . . . . . . . . . . 6
- /M Force monochrome colors. . . . . . . . . . . 6
- /P[file] Use "passthru" or non-resident mode. . . . . 6
- /Rnnnnn Read buffer of nnnnn bytes . . . . . . . . . 6
- /S Enable snow checking. . . . . . . . . . . . . 7
- /U Uninstall (remove) from memory . . . . . . . 7
- /W Start in read/write file access mode. . . . . 7
- /Z Start zoom mode for Browse in expanded
- state. . . . . . . . . . . . . . . . . . . . 7
-
- Help . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
- Generic Help (Alt-F1) . . . . . . . . . . . . . . . . . . . 8
- Context Sensitive Help (F1) . . . . . . . . . . . . . . . . 8
-
- Alt Menu (Alt) . . . . . . . . . . . . . . . . . . . . . . . . . 9
- Alt Action Keys . . . . . . . . . . . . . . . . . . . . . . 9
- Alt Toggle Keys . . . . . . . . . . . . . . . . . . . . . . 9
- Toggle Indicator Summary . . . . . . . . . . . . . . . . . . 10
-
- Pick File (Alt-P) . . . . . . . . . . . . . . . . . . . . . . . . 11
- Select Directory/File/Index (Enter) . . . . . . . . . . . . 11
- Move to Parent Directory (BackSpace) . . . . . . . . . . . . 11
- Change Directory and/or Drive (F2) . . . . . . . . . . . . . 11
- Enter A Specific File (F3) . . . . . . . . . . . . . . . . . 11
- Change File Specification (F4) . . . . . . . . . . . . . . . 11
- Change Default Action (F5) . . . . . . . . . . . . . . . . . 12
-
- i
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Table of Contents Table of Contents
-
-
-
- Move to Current DOS Drive & Directory (F10) . . . . . . . . 12
- Frequent Database Access (Alt-1 thru 0) . . . . . . . . . . 12
-
- View Structure (Alt-S) . . . . . . . . . . . . . . . . . . . . . 13
- Number/Un-Number Fields (Space) . . . . . . . . . . . . . . 13
- Clear Field Numbers (F2) . . . . . . . . . . . . . . . . . . 13
- Assign a Specific Field Number (F3) . . . . . . . . . . . . 13
- Order Fields Using Field Numbers (F4) . . . . . . . . . . . 13
- Tag/Un-Tag Field for Exclusive Find (F6) . . . . . . . . . . 13
- Clear Exclusive Find Tags (F7) . . . . . . . . . . . . . . . 13
- Print the File Structure (F9) . . . . . . . . . . . . . . . 14
-
- Browse Records (Alt-B) . . . . . . . . . . . . . . . . . . . . . 15
- Current Record and Delete Status . . . . . . . . . . . . . . 15
- Pan the Browse Window ( / ) . . . . . . . . . . . . . . . . 15
- View Large Fields (Tab/Shift-Tab) . . . . . . . . . . . . . 15
- Zoom the Browse Window (F2) . . . . . . . . . . . . . . . . 15
- Goto a Specific Record (F3) . . . . . . . . . . . . . . . . 15
- Find Text (F7) . . . . . . . . . . . . . . . . . . . . . . . 15
- Find Next Occurrence of Text (F8) . . . . . . . . . . . . . 16
- Print Records (F9) . . . . . . . . . . . . . . . . . . . . . 16
- Turn Century On/Off (Ctrl-C) . . . . . . . . . . . . . . . . 16
-
- Edit/Append Records (Alt-E/Alt-A) . . . . . . . . . . . . . . . . 17
- Copy a Record (F2) . . . . . . . . . . . . . . . . . . . . . 17
- Goto a Specific Record (F3) . . . . . . . . . . . . . . . . 17
- Find Text (F7) . . . . . . . . . . . . . . . . . . . . . . . 17
- Find Next Occurrence of Text (F8) . . . . . . . . . . . . . 17
- Field Information (F10) . . . . . . . . . . . . . . . . . . 17
- Turn Century On/Off (Ctrl-C) . . . . . . . . . . . . . . . . 17
- System Date (Ctrl-D) . . . . . . . . . . . . . . . . . . . . 17
- Move to Last Field Position (Ctrl-E) . . . . . . . . . . . . 17
- Restore Field Data (Ctrl-F) . . . . . . . . . . . . . . . . 17
- Abort and Lose Changes (Ctrl-Q/Esc) . . . . . . . . . . . . 18
- Restore Entire Record (Ctrl-R) . . . . . . . . . . . . . . . 18
- Mark Record as Deleted (Ctrl-U) . . . . . . . . . . . . . . 18
- Quit and Save Changes (Ctrl-W/Ctrl-End) . . . . . . . . . . 18
- Blank Current Field (Ctrl-Y) . . . . . . . . . . . . . . . . 18
- Blank to End of Field (Ctrl-Delete) . . . . . . . . . . . . 18
- Move to End of Data (End) . . . . . . . . . . . . . . . . . 18
- Move to First Position (Home) . . . . . . . . . . . . . . . 18
- Move Word (Ctrl- /Ctrl- ) . . . . . . . . . . . . . . . . . 18
- Move to First/Last Field on Screen (Ctrl- /Ctrl- ) . . . . . 18
-
-
-
-
-
- ii
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Introduction Introduction
-
-
- Introduction Introduction ____________
-
- Copyright and Registration Information Copyright and Registration Information
- PopDBF, its documentation and supplementary files and programs are
- copyright (C) 1989-90 Bowen Software. All rights reserved worldwide.
-
- PopDBF is not now, nor was it ever, public domain or free software.
- PopDBF is currently available in shareware and commercial versions.
-
- Non-registered users are granted a limited license for trial use of
- PopDBF for 21 days. After 21 days if you continue to use PopDBF you
- MUST register it. Use of PopDBF after the 21 day trial period
- violates Bowen Software's license.
-
- Registration of PopDBF is mandatory for commercial and government
- users.
-
- Registered users are provided services and software not available to
- the non-registered user. Registered users are notified of program
- updates and provided the first update FREE! Also, the registered
- version of PopDBF does NOT contain the registration information
- screen, which pops up on the screen at each invocation of PopDBF.
-
- Under no circumstances shall any other person or business profit from
- the sale of this program, other than to distribute the program in a
- shareware library. Bowen Software hereby grants permission to
- distribute the DEMO VERSION of PopDBF in a shareware library or on any
- bulletin board system provided the files are not modified in any way
- and no more than a $10 distribution fee is charged.
-
- To register your copy of PopDBF, send your registration fee to:
-
- Bowen Software Bowen Software
- P.O. Box 2134 P.O. Box 2134
- East Peoria, Illinois 61611 East Peoria, Illinois 61611
-
- How to Contact Bowen Software How to Contact Bowen Software
- Bowen Software shareware products have their home on the Exec-PC
- bulletin board located in Milwaukee, Wisconsin. The Exec-PC phone
- number is (414) 789-4210. Electronic messages can be left on Exec-PC
- and should be addressed to Don Bowen. This is also where you can find
- the latest version of PopDBF and other programs by Bowen Software.
-
- You can also contact Bowen Software by leaving messages on Compuserve,
- our number is 76665,736 or by calling direct at (309) 699-0950.
-
-
-
-
- 1
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Introduction Introduction
-
-
- Software Support Software Support
- Registered and commercial users are provided free phone support for
- six months. No support is guaranteed for non-registered users, but we
- are happy to answer questions about our products and consulting
- services. Bowen Software can be reached at (309) 699-0950.
- Registered users will be asked for their serial number.
-
- Trademark Acknowledgements Trademark Acknowledgements
- CLIPPER is a trademark of Nantucket Corporation. CLIPPER
-
- COMPAQ is a registered trademark of COMPAQ Computers, Inc. COMPAQ
-
- dBASE and dBASE III are registered trademarks of Ashton Tate, Inc. dBASE and dBASE III
-
- dBASE III Plus and dBASE IV are trademarks of Ashton Tate, Inc. dBASE III Plus and dBASE IV
-
- FoxBASE+ is a registered trademark of Fox Software, Inc. FoxBASE+
-
- PopDBF is a trademark of Bowen Software. PopDBF
-
- Quicksilver is a trademark of Wordtech Systems, Inc. Quicksilver
-
- Sidekick and Sidekick Plus are trademarks of Borland International, Sidekick Sidekick Plus
- Inc.
-
- Disclaimer and Warranty Disclaimer and Warranty
- This software is provided "as is" without any warranty of any kind,
- either expressed or implied, including, but not limited to, the
- implied warranties of merchantability and fitness for a particular
- purpose. The entire risk as to the quality and performance of the
- software is with you. Should the software prove defective, the user,
- NOT Bowen Software, assumes the entire cost of all necessary
- servicing, repair or correction.
-
- In no event shall Bowen Software be liable to the user for any
- damages, including lost profits, lost savings or other incidental or
- consequential damages arising out of the use or inability to use this
- software, even if Bowen Software has been advised of the possibility
- of such damages, or for any claim by any other party.
-
-
-
-
-
-
-
-
-
-
- 2
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Getting Started Getting Started
-
-
- Getting Started Getting Started _______________
-
- Description Description
- PopDBF is a memory resident program that will give you "instant
- access" to Clipper, dBASE III Plus, dBASE IV, FoxBASE+, and
- Quicksilver (or any other dBASE compatible) files from anywhere at the
- press of the hotkey (Alt-BackSpace). It provides an easy way to move
- throughout your hard disk(s) and find your database files. It also
- has context sensitive help for novice (or forgetful) users.
-
- You can use PopDBF to:
-
- pick database file
- view file structure
- print file structure
- browse records
- print records
- search for strings anywhere in a database
- append and edit records
- specify fields and assign their order for the above features
- view index expressions of index files
-
- PopDBF has four main areas, Pick File, View Structure, Browse Records,
- and Edit/Append Records. These areas are described more fully below
- along with the actions available from each.
-
- Limitations Limitations
- Though PopDBF has many features, it does not do everything, yet!.
-
- Currently PopDBF does not do the following:
-
- allow two or more users on a network to access the same file
- view or edit memo fields
- use index files (it does display the expression used to
- create them)
- view more than one database file at a time.
- handle database files with more 65,535 records.
- handle fields larger than 1080 characters.
- install itself in extended memory.
-
- Cautions Cautions
- When using PopDBF from within any product that allows editing of dBASE
- compatible files, like dBASE, it is important to remember that most of
- those products do internal record buffering. This means that if a
- record is changed in dBASE and resides in a dBASE internal buffer, it
- will NOT reflect that change when viewed from within PopDBF.
-
-
-
- 3
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Getting Started Getting Started
-
-
- Likewise, if a record is changed in PopDBF while that same record is
- in an internal dBASE buffer, the change will be overwritten by dBASE
- when it closes the file and/or flushes the internal buffer.
-
- As a general rule, do not change records in a database that might be
- opened by dBASE or any of its compatibles.
-
- Installing PopDBF Files on Your Hard Disk Installing PopDBF Files on Your Hard Disk
- To load the PopDBF files on your hard disk do the following:
-
- make drive A: your default drive by typing A: and pressing A:
- RETURN. RETURN
-
- place the PopDBF diskette in drive A: and type POPINST <dir> POPINST <dir>
- and press RETURN. <dir> is the directory where you want the RETURN
- PopDBF files installed. If you don't specify <dir> it will
- default to POPDBF.
-
- When PopDBF is executed it assumes that POPDBF.HLP, the context
- sensitive help file, and POPDBF.FRQ, the frequent database list, are
- in the same directory as POPDBF.COM. If either of those files are not
- in that directory, their corresponding features will not function.
- See "Help" on page 8 and "Frequent Database Access" on page 12. Help Frequent Database Access
-
- Modifying AUTOEXEC.BAT to Load PopDBF Modifying AUTOEXEC.BAT to Load PopDBF
- To load PopDBF at boot time, add the following line to your
- AUTOEXEC.BAT file:
-
- . .
- [path\]POPDBF [arguments] <load PopDBF into memory> [path\]POPDBF [arguments]
- . .
-
- If the optional path is not specified POPDBF.COM must either be in the
- current directory or in the PATH.
-
- For help on which arguments to use when loading PopDBF see "Command "Command
- Line Arguments" on page 5. Line Arguments"
-
- You can conserve memory by loading PopDBF (or any other memory
- resident program) before doing any PROMPT, PATH or SET commands. For
- additional memory saving tips see /E, /F, and /R under "Command Line /E /F /R "Command Line
- Arguments" on page 5. Arguments"
-
- PopDBF does not need to be the last memory resident program. However,
- it can NOT be uninstalled from memory if it isn't the last memory
- resident program or if another memory resident program has recaptured
- one of PopDBF's interrupts.
-
-
- 4
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Getting Started Getting Started
-
-
- How to Invoke PopDBF (Using the "Hotkey") How to Invoke PopDBF (Using the "Hotkey")
- By default the hotkey to invoke PopDBF is Alt-BackSpace. To invoke Alt-BackSpace
- PopDBF, press and hold the Alt key and at the same time press the
- BackSpace key. The commercial version includes a program that will
- allow you to change this default.
-
- As soon as you press the PopDBF hotkey, the PopDBF program will "pop"
- onto the screen. Pressing the hotkey again will take you right back
- to the interrupted program. You can "hotkey" out of PopDBF from
- anywhere in the program except when you are being prompted for
- information. At those times, pressing the hotkey will abort that
- action just as if you had pressed Esc.
-
- When you press the hotkey to leave PopDBF any open database is closed.
- Pressing the hotkey again will return you to the same location in
- PopDBF with the file being opened automatically as if it had never
- been closed. You can even hotkey out and back in while using Edit or
- Append!
-
- Command Line Arguments Command Line Arguments
- To load or execute PopDBF type the following at the DOS prompt:
-
- PopDBF [arguments], where arguments can be: PopDBF [arguments]
-
- /A<ltr> Default action, /A<ltr>
- where <ltr> = <A>ppend <B>rowse <E>dit <S>tructure A B E S
-
- /D<dir> Initial PopDBF Directory /D<dir>
-
- The format of <dir> is [d:]path, where d: is the
- optional drive identifier.
-
- The initial PopDBF directory is set to the current DOS
- directory the first time PopDBF invoked, if this option
- is not specified.
-
- The PopDBF directory changes only when a move is made
- from within PopDBF. Each time PopDBF is invoked, the
- current DOS directory is saved and the PopDBF directory
- becomes the current directory. When leaving PopDBF the
- DOS directory is restored. See also "Move to Current "Move to Current
- DOS Directory" on page 12. DOS Directory"
-
- /Ennnnn Edit buffer of nnnnn bytes (default = 1024). /Ennnnn
-
- If a file has a record size larger than the edit buffer
- size, you will not be allowed to Edit or Append.
-
-
- 5
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Getting Started Getting Started
-
-
- You can conserve memory by specifying a buffer size as
- small as 0. However, if the buffer is too small you
- will not be allowed to Edit or Append.
-
- /Fnnnn Maximum of nnnn fields (default = 64). /Fnnnn
-
- The default value should handle most needs, however
- Clipper databases can have up to 1024 fields.
-
- The maximum number of fields also determines the
- maximum number of files that the Pick File window can
- display. To calculate the maximum number of files,
- multiply the maximum number of fields by 21 and divide
- by 14. The default is 96 (64 x 21 / 14 = 96).
-
- You can conserve memory by specifying less than the
- default number of fields. The savings is 21 bytes per
- field.
-
- /H Display brief description of command line arguments. /H
-
- /M Force monochrome colors. /M
-
- On some monitors, like the COMPAQ portable gas plasma
- monitor, this is necessary to be able to see menu lite-
- bars and hi-intensity text.
-
- /P[file] Use "passthru" or non-resident mode. /P[file]
-
- This option will NOT load PopDBF into memory, but will NOT
- allow you to use all of its features.
-
- If a file is also specified (no brackets are
- necessary), PopDBF will automatically come up in
- Browse, unless the /A option is used to specify a /A
- different action.
-
- This option can also be used even if PopDBF is already
- in memory. This allows the resident program to be
- called from batch files and other programs which allow
- you to run DOS commands.
-
- /Rnnnnn Read buffer of nnnnn bytes (default = 4096). /Rnnnnn
-
- If a file's record size is larger that the read buffer
- size, you will not be allowed to Browse the file.
-
-
-
- 6
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Getting Started Getting Started
-
-
- The larger the read buffer the faster scrolling and
- finding will be done when in Browse and Edit.
-
- You can conserve memory by specifying a buffer size as
- small as 0. However, the only reason for doing so
- would be to use PopDBF as a structure viewer, because
- if the buffer is too small you will not be allowed to
- Browse, Edit or Append the database.
-
- /S Enable snow checking. /S
-
- Older color graphic adapters (CGA) produce snow or
- sparkle when accessing video memory directly. PopDBF
- gets some of its speed by directly accessing video
- memory. If you see snow on your monitor, using this
- argument should eliminate most of the distraction.
-
- /U Uninstall (remove) from memory /U
-
- This will remove PopDBF from memory, but ONLY if it is
- the last memory resident program.
-
- In some special cases, even when PopDBF is the last
- memory resident program it can't be removed from
- memory. This occurs if another resident program re-
- steals one of the interrupt vectors after PopDBF has
- chained into it. Sidekick and Sidekick Plus are
- examples of this type of program.
-
- /W Start in read/write file access mode. /W
-
- PopDBF's default file access mode is read-only. This
- is to prevent accidentally getting into Edit and
- changing data. Specifying this argument will override
- that default. See also "Alt Toggle Keys" on page 9. "Alt Toggle Keys"
-
- /Z Start zoom mode for Browse in expanded state. /Z
-
- By default the Browse window shows only 12 records.
- When zoomed it will show 18 records. See also "Zoom Zoom
- Browse Window" on page 15. Browse Window
-
-
-
-
-
-
-
-
- 7
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Help Help
-
-
- Help Help ____
-
- Help is available in PopDBF only if the file POPDBF.HLP is in the same
- directory as POPDBF.COM, the main program.
-
- While in Help you can press the up and down arrow keys as well as PgUp
- and PgDn to scroll the help text. To get out of Help, press Esc.
-
- Generic Help (Alt-F1) Generic Help (Alt-F1)
- You can get generic help about the system by pressing Alt-F1 from any
- area of the program.
-
- This help explains the Alt Action and Toggle Keys and the toggle
- indicators. See "Alt Menu" on page 9. It also explains cursor and "Alt Menu"
- lite-bar movement.
-
- Context Sensitive Help (F1) Context Sensitive Help (F1)
- Pressing F1 will provide specific help for any area of PopDBF. The
- help provided is essentially the same text found in this manual. Some
- areas of PopDBF are explained only in context sensitive help.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- 8
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Alt Menu Alt Menu
-
-
- Alt Menu (Alt) Alt Menu (Alt) ______________
-
- Pressing the Alt key will show the Alt menu on the status line.
- Releasing the Alt key will restore the previous status line. The Alt
- menu is divided into two parts, "Action Keys" and "Toggle Keys".
- Pressing Alt and one of the highlighted Action Keys will cause the
- appropriate action to occur. Pressing Alt and one of the highlighted
- Toggle Keys will toggle the appropriate indicator in the indicator
- window located in the lower left border of the main window.
-
- Alt Action Keys Alt Action Keys
- Alt Action Keys will have no effect when responding to an error, a
- prompt, or inside of Help. They also have no effect while positioned
- on a directory in the Pick File window.
-
- The Alt Action Keys are:
-
- Alt-A Append records in the current database. Ignored if
- file access mode is read-only.
-
- Alt-B Browse records in the current database. If pressed
- while in Edit or Append is the same as pressing Esc to
- abort. See "Abort and Lose Changes" on page 18. Abort and Lose Changes
-
- Alt-E Edit records in the current database. If the file
- access mode is read-only, Edit acts as a full screen
- record viewer.
-
- Alt-P Pick a different database or directory. If pressed
- while in Edit or Append is the same as pressing Esc to
- abort.
-
- Alt-S View field structure of current database. If pressed
- while in Edit or Append is the same as pressing Esc to
- abort.
-
- Alt Toggle Keys Alt Toggle Keys
- Alt Toggle Keys will function regardless of where you are in the
- program.
-
- The Alt Toggle Keys are:
-
- Alt-C Toggles the case sensitivity indicator between "IC",
- ignore case, and "CS", case sensitive. This indicator
- affects how the Find function does its search. See
- "Find Text" on page 15. "Find Text"
-
-
-
- 9
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Alt Menu Alt Menu
-
-
- Alt-D Toggles the field border indicator between "NB", no
- borders, and "BO", borders on. This indicator also
- affects how the Find function behaves.
-
- Alt-I Toggles the insert/overstrike indicator between "IN",
- insert mode, and "OV", overstrike mode. This indicator
- affects how text is placed into fields in Edit. It can
- also be toggled by pressing Insert.
-
- Alt-M Toggles the file access mode indicator between "RO",
- read-only mode, and "RW", read-write mode. When the
- file access mode is read-only, you will not be allowed
- to Edit or Append.
-
- Toggle Indicator Summary Toggle Indicator Summary
- The default values for the toggle indicators are given below.
-
- RW IC NB OV
-
- IN/OV: edit mode is insert/overstrike
- NB/BO: field borders are off/on
- IC/CS: case sensitivity is off/on
- RO/RW: file access mode is read-only / read/write
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- 10
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" Pick File PopDBF - "Instant Access to dBASE Files" Pick File
-
-
- Pick File (Alt-P) Pick File (Alt-P) _________________
-
- Pressing any letter will move the lite-bar to the first file or
- directory that begins with that letter. Successive presses of the
- same letter will move to the next file or directory that begins with
- that letter. If no file or directory begins with the letter pressed,
- no movement will occur.
-
- Select Directory/File/Index (Enter) Select Directory/File/Index (Enter)
- Pressing RETURN will cause one of the following to occur: RETURN
-
- If the file is a directory, you will move to that directory.
- Once in that directory the Pick File window is refreshed
- with the names of files that match the file specification.
-
- If the file is a database, the action taken corresponds to
- the currently specified Action letter. This can be changed
- by pressing F5 (see "Change Default Action" on page 12). It "Change Default Action"
- is the same as pressing Alt-<action letter>.
-
- If the file is an index (.NDX, .IDX, .NTX only), you will
- view the index expression used to create it.
-
- Move to Parent Directory (BackSpace) Move to Parent Directory (BackSpace)
- Pressing BackSpace will take you to the parent of the current
- directory, unless you are currently in the root directory.
-
- Change Directory and/or Drive (F2) Change Directory and/or Drive (F2)
- Pressing F2 will allow you to change the current PopDBF directory
- and/or drive. The name supplied can be a drive letter followed by a
- colon (C:), a directory path (\DON\BOWEN), or both (C:\DON\BOWEN).
-
- If the new directory is invalid, an error message will be displayed.
- If the new directory is valid the file selection window will be filled
- with files matching the current file specification in that directory.
-
- Enter A Specific File (F3) Enter A Specific File (F3)
- Pressing F3 will allow you to enter a specific file name. If the file
- is not found or is not a valid database or index, an error message
- will be displayed. If no extension is entered, the extension in the
- file specification will be used. This will cause an error if that
- extension contains a wildcard (*/?) and you will need to enter the
- file extension as well.
-
- Change File Specification (F4) Change File Specification (F4)
- Pressing F4 will allow you to modify the file specification located in
- the upper right corner of the main window. The file specification is
- used to determine which files in the current PopDBF directory you are
- allowed to pick from. Entering a file specification of *.* will allow
-
- 11
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" Pick File PopDBF - "Instant Access to dBASE Files" Pick File
-
-
- you to pick from all files, while *.DBF will allow only files with an
- extension of .DBF.
-
- The names of any sub-directories in the current PopDBF directory are
- included for possible selection regardless of the file specification.
-
- Change Default Action (F5) Change Default Action (F5)
- The current default action is displayed in the upper left portion of
- the file selection window. The default action determines what happens
- when you press Enter when the selection bar is on a valid database
- file. Each press of F5 will change the action letter as follows:
-
- [A]ppend -> [B]rowse -> [E]dit -> [S]tructure -> [A]ppend, etc. A B E S A
-
- The result is the same as holding the Alt key and pressing that
- letter. You can override the default action by holding the Alt key
- and pressing a different action key.
-
- Move to Current DOS Drive & Directory (F10) Move to Current DOS Drive & Directory (F10)
- Pressing F10 will move you to the current DOS directory. The current
- DOS directory is the directory you were in before the PopDBF hotkey
- was pressed. If that directory is on a drive other than the current
- drive, that drive becomes the current drive as well.
-
- Frequent Database Access (Alt-1 thru 0) Frequent Database Access (Alt-1 thru 0)
- To use this feature you must have already created an ASCII file named
- POPDBF.FRQ containing the names of up to 10 frequently used databases.
- Each database name can include a drive identifier and path. It MUST
- include file name and extension. Optionally, each file can be
- preceded by an action letter and a space. See "Change Default Action" "Change Default Action"
- on page 12 for more information on action letters.
-
- Pressing Alt-1 will access the database whose name is on the first
- line of this file, Alt-2 will access the second, and so on. If more
- than 10 lines are in POPDBF.FRQ they are ignored. The file POPDBF.FRQ
- must reside in the same directory as POPDBF.COM.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- 12
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- View Structure View Structure
-
-
- View Structure (Alt-S) View Structure (Alt-S) ______________________
-
- Pressing any letter will move the lite-bar to the first field that
- begins with that letter. Successive presses of the same letter will
- move to the next field that begins with that letter. If no field
- begins with the letter pressed, no movement will occur.
-
- Number/Un-Number Fields (Space) Number/Un-Number Fields (Space)
- Pressing the Space bar will number/un-number the field at the
- selection bar. If any fields are numbered, only those fields will be
- shown when you Browse or Edit records. The number beside the field
- determines the order in which it will be displayed. Two fields with
- the same number will remain in the same relative position to each
- other.
-
- Clear Field Numbers (F2) Clear Field Numbers (F2)
- Pressing F2 will clear all field numbers, but leave the file structure
- in the present order. This means that you can assign field numbers,
- press F4 to order the fields, and then remove all field numbers by
- pressing F2. This will allow you to view all fields but in an order
- different from the original. Field numbers are also cleared when a
- new file is selected from the Pick File window.
-
- Assign a Specific Field Number (F3) Assign a Specific Field Number (F3)
- Pressing F3 will allow you to assign a specific number (0-1024) to a
- field to affect its order. Assigning a zero will un-number the field.
-
- Order Fields Using Field Numbers (F4) Order Fields Using Field Numbers (F4)
- Pressing F4 will reorder the fields in the structure based on their
- field numbers. THIS NEW ORDER IS NOT PERMANENT. The actual structure
- of the file on disk is NOT affected. To restore the original field
- order either return to the Pick File window and re-select the file or
- clear all field numbers and press F4 again.
-
- Tag/Un-Tag Field for Exclusive Find (F6) Tag/Un-Tag Field for Exclusive Find (F6)
- Pressing F6 will tag/un-tag the field at the selection bar for
- exclusive find. When any fields are tagged for exclusive find, only
- those fields are used when doing a Find or Find Next from Browse or
- Edit. Also, if the field border indicator is on (see "Toggle "Toggle
- Indicators Summary" on page 10), the text being searched for MUST be Indicators Summary"
- found entirely within ONE field. For more information see "Find Text" "Find Text"
- on page 15.
-
- Clear Exclusive Find Tags (F7) Clear Exclusive Find Tags (F7)
- Pressing F7 will turn off the exclusive find indicator for all fields.
- This will allow Find and Find Next to locate text anywhere in the
- record, unless field borders are on, in which case it must be entirely
-
-
- 13
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- View Structure View Structure
-
-
- within ONE field. Exclusive find tags are also cleared when a new
- file is selected from the Pick File window.
-
- Print the File Structure (F9) Print the File Structure (F9)
- Pressing F9 will print the file structure. If any fields are numbered
- only those fields will be printed. The file statistics are printed
- first followed by the field structure.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- 14
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Browse Records Browse Records
-
-
- Browse Records (Alt-B) Browse Records (Alt-B) ______________________
-
- Current Record and Delete Status Current Record and Delete Status
- The current record number and delete status are displayed in the
- bottom border of the Browse window.
-
- Pan the Browse Window ( / ) Pan the Browse Window ( / )
- The LeftArrow and RightArrow will allow you to pan to the left and
- right, respectively.
-
- View Large Fields (Tab/Shift-Tab) View Large Fields (Tab/Shift-Tab)
- Tab and Shift-Tab change the offset of fields that are wider than the
- Browse window. The offset is incremented or decremented by 10
- characters. The current offset is displayed in the upper right-hand
- corner of the Browse window.
-
- Zoom the Browse Window (F2) Zoom the Browse Window (F2)
- Pressing F2 will either expand or contract the Browse window. When
- expanded the window shows 18 records and when contracted shows only
- 12, but has the advantage of allowing you to see the file statistics
- as well.
-
- Goto a Specific Record (F3) Goto a Specific Record (F3)
- Pressing F3 will prompt you for a new record position. If the record
- number specified is greater than the number of records in the file, an
- error will occur and the lite-bar will stay on the same record.
-
- Find Text (F7) Find Text (F7)
- Pressing F7 will prompt you for the text you want to locate. Memo
- fields are not searched and dBASE dates need to be searched as
- follows. If the date you are looking for is 11/03/89 you would enter:
- "891103" or "19891103" (don't enter the quotes).
-
- When the case sensitivity indictor is off (IC) finding "don" will
- locate records containing "Don", "DON", and other combinations. To
- find only occurrences of "don", you must first turn on the case
- sensitivity indicator (CS) by pressing Alt-C.
-
- There may be times that you want to find text only if it occurs in a
- specific field or fields, not just anywhere in the record. To do this
- press Alt-S for the View Structure window. Now tag the fields you
- want searched exclusively by pressing F6. When you have tagged the
- fields to be searched, press Alt-B to return to the Browse window.
- Now Find will search only the fields you tagged.
-
- By default Find will locate text even if it crosses field boundaries.
- To prevent this you can turn on the field border indicator by pressing
-
-
- 15
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Browse Records Browse Records
-
-
- Alt-D. When field borders are on (BO), text must be found entirely
- within ONE field.
-
- Find can also be used to locate deleted records. Do a find for "*"
- and make sure that field borders are off and no fields have been
- tagged for exclusive find.
-
- Find ALWAYS begins with the first record in the file. See "Find Next Find Next
- Occurrence of Text" below to see how to start Find at the current Occurrence of Text
- record.
-
- If Find fails a beep will sound.
-
- Find Next Occurrence of Text (F8) Find Next Occurrence of Text (F8)
- Pressing F8 will do a Find Next. Find Next ALWAYS begins with the
- next record in the file.
-
- To start a Find at the current record you can use Find Next. Press F7
- to enter the find text and then press Esc. This will cause the find
- text window to disappear. Now press F8 and the search will begin at
- the next record.
-
- If Find Next fails a beep will sound.
-
- Print Records (F9) Print Records (F9)
- Pressing F9 prompts for print parameters and then prints the data. The
- parameters you will be asked for are the starting record, ending
- record, if only records matching the find text should be used, and the
- width of the print line. Data is printed exactly as it is seen in the
- Browse window, but more text may be printed if a longer print width is
- specified (this is how you print the additional data to the right of
- the Browse window).
-
- Print can be used in conjunction with the find text string to print
- only records that contain certain text. Find behaves here as
- described above under "Find Text". Find Text
-
- The maximum print width is 250 characters.
-
- Turn Century On/Off (Ctrl-C) Turn Century On/Off (Ctrl-C)
- Pressing Ctrl-C will toggle the century on or off. When on, the date
- is formatted as MM/DD/YYYY.
-
-
-
-
-
-
-
- 16
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Edit/Append Records Edit/Append Records
-
-
- Edit/Append Records (Alt-E/Alt-A) Edit/Append Records (Alt-E/Alt-A) _________________________________
-
- Copy a Record (F2) Copy a Record (F2)
- Pressing F2 will prompt you for the number of the record you want to
- copy into the current record. To append a duplicate of a current
- record you must first go into Append by pressing Alt-A. Then press F2
- and specify the number of the record to copy. To complete the
- operation, press PgDn.
-
- Pressing Ctrl-F2 will also copy a record, but will use the last record
- you specified to be copied instead of prompting you.
-
- Goto a Specific Record (F3) Goto a Specific Record (F3)
- Pressing F3 works the same as it does in Browse. See "Goto a Specific Goto a Specific
- Record" on page 15. Record
-
- Find Text (F7) Find Text (F7)
- Pressing F7 works the same as it does in Browse. See "Find Text" on Find Text
- page 15.
-
- Find Next Occurrence of Text (F8) Find Next Occurrence of Text (F8)
- Pressing F8 works the same as it does in Browse. See "Find Next Find Next
- Occurrence of Text" on page 16. Occurrence of Text
-
- Field Information (F10) Field Information (F10)
- Pressing F10 will pop-up a window containing information about the
- field in which the cursor is currently positioned. This can be
- helpful if you forget the field type or want to know exactly how long
- it is.
-
- Turn Century On/Off (Ctrl-C) Turn Century On/Off (Ctrl-C)
- Pressing Ctrl-C works the same as it does in Browse. See "Turn Turn
- Century On/Off" on page 16. Century On/Off
-
- System Date (Ctrl-D) System Date (Ctrl-D)
- Pressing Ctrl-D while in a date field will place the system date in
- the field. It will only work in a character field if enough room
- remains from the cursor to the end of the field. It will also
- overwrite any existing data in the field at those positions.
-
- Move to Last Field Position (Ctrl-E) Move to Last Field Position (Ctrl-E)
- Pressing Ctrl-E will move the cursor to the last possible position in
- a field.
-
- Restore Field Data (Ctrl-F) Restore Field Data (Ctrl-F)
- Pressing Ctrl-F will restore the field's original data. Once you have
- moved to another record any changes that were made become permanent
- and can NOT be restored.
-
- 17
-
-
-
-
-
-
-
-
-
-
-
-
- PopDBF - "Instant Access to dBASE Files" PopDBF - "Instant Access to dBASE Files"
- Edit/Append Records Edit/Append Records
-
-
-
- Abort and Lose Changes (Ctrl-Q/Esc) Abort and Lose Changes (Ctrl-Q/Esc)
- Pressing Ctrl-Q or Esc will leave Edit and any changes made to the
- current record will be lost. If any changes have been made you will
- be asked if you want to lose the changes. Pressing escape will abort
- and leave you in Edit. Pressing N will save the changes and then
- exit, while pressing Y will exit and the changes will be lost.
-
- Restore Entire Record (Ctrl-R) Restore Entire Record (Ctrl-R)
- Pressing Ctrl-R will restore the entire record's original data. See
- "Restore Field Data" above for when changes in the current record "Restore Field Data"
- become permanent.
-
- Mark Record as Deleted (Ctrl-U) Mark Record as Deleted (Ctrl-U)
- Pressing Ctrl-U will toggle the delete status of the current record.
- The delete status of the current record is displayed in the bottom
- border of the Edit (and Browse) window. See "Find Text" on page 15 Find Text
- for a tip on how to find deleted records.
-
- Quit and Save Changes (Ctrl-W/Ctrl-End) Quit and Save Changes (Ctrl-W/Ctrl-End)
- Pressing Ctrl-W or Ctrl-End will quit Edit and save any changes made
- to the current record.
-
- Blank Current Field (Ctrl-Y) Blank Current Field (Ctrl-Y)
- Pressing Ctrl-Y will fill the current field with spaces.
-
- Blank to End of Field (Ctrl-Delete) Blank to End of Field (Ctrl-Delete)
- Pressing Ctrl-Delete will delete from the current cursor position in
- the current field to the end of the field.
-
- Move to End of Data (End) Move to End of Data (End)
- Pressing the End key will move the cursor to the first blank position
- after any data entered in the current field.
-
- Move to First Position (Home) Move to First Position (Home)
- Pressing the Home key will move the cursor to the first position of
- the current field.
-
- Move Word (Ctrl- /Ctrl- ) Move Word (Ctrl- /Ctrl- )
- Pressing Ctrl-LeftArrow or Ctrl-RightArrow will move one word to the
- left or right, respectively.
-
- Move to First/Last Field on Screen (Ctrl- /Ctrl- ) Move to First/Last Field on Screen (Ctrl- /Ctrl- )
- Pressing Ctrl-UpArrow and Ctrl-DownArrow will move to the first and
- last field respectively, on the current screen.
-
-
-
-
- 18
-
-
-
-
-
-
-